SongAlbumRecording
Mood Indigo Ellington Indigos 757
   "More Jazz and Big Band Classics 2182
   "For Dancers Only 1644
   "Move 1678
   "Best of the Big Bands, The 1811
   "Four Freshmen, The 2718
   "Giants of Jazz - Duke Ellington 3196
   "Boswell Sisters on the Net, The 3762
   "Big Band Jazz 5455
   "Savina and All That Gentle Jazz 5554
   "Big Band Feeling, The 7229
   "Mood Indigo 8119
   "Jonathan Plays Fats (Almost), Darlene Remembers Duke (Sometimes) 11356
   "Songs You Love to Remember 11661
   "Duke Ellington on RCA 11740

SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Mood Indigo"